CREATE TABLE [dbo].[PSFull]
(
[Account Number] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Account Number - Buy Lot] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Account Period Change Date] [datetime] NULL,
[Actual Settlement Date] [datetime] NULL,
[Adjustment Indicator] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Asset Class Code] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Asset Group Code] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Asset Group Name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Asset ID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Average Cost (Base)] [float] NULL,
[Average Cost (Local)] [float] NULL,
[Average Currency Gn/Ls] [float] NULL,
[Base 5 Year Gain/Loss Amount] [float] NULL,
[Base Amortization Sold] [float] NULL,
[Base Amortization Sold - Buy Lot] [float] NULL,
[Base Currency Code] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Base Currency Gain] [float] NULL,
[Base Currency Gain/Loss] [float] NULL,
[Base Currency Loss] [float] NULL,
[Base Fees] [float] NULL,
[Base Long Term Gain/Loss - Buy Lot] [float] NULL,
[Base Net Proceed Amount] [float] NULL,
[Base Original Average Cost] [float] NULL,
[Base Original Identified Cost] [float] NULL,
[Base Realized Gain] [float] NULL,
[Base Realized Gain/Loss] [float] NULL,
[Base Realized Loss] [float] NULL,
[Base Security Gain/Loss] [float] NULL,
[Base Short Term Gain/Loss - Buy Lot] [float] NULL,
[Bifurcation Flag] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Bloomberg Expanded Ticker] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Bloomberg Ticker] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Broker] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Broker Number] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Broker Reason Code] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Call/Put Indicator] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Cancel Post Date] [datetime] NULL,
[Cancel Reason Code] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Cancel Report Date] [datetime] NULL,
[Cancel Trade ID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Canceled] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Cash Broker Flag] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Cash Costing Code] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Cash Cusip Flag] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Cash Reason Code] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Client Fund Reference Number] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Client ID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Client Name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Closing Date] [datetime] NULL,
[Closing Price] [float] NULL,
[Commission (Base)] [float] NULL,
[Commission (Local)] [float] NULL,
[Commission Per Share] [float] NULL,
[Contractual Settle Date] [datetime] NULL,
[Contributed Property Flag] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Contributing ID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Corporate Action Broker Flag] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Costing Method] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Country Code] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Country of Risk Code] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Currency 5 Year Gain/Loss] [float] NULL,
[Current Multiplier] [float] NULL,
[Days Past Due] [float] NULL,
[Days to Maturity] [float] NULL,
[Delay Date] [datetime] NULL,
[Delay Date Flag] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Delay Days] [float] NULL,
[Detail Transaction Type] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Dirty Shares Adjusted] [float] NULL,
[Dirty Shares Sold] [float] NULL,
[Dummy Cusip Indicator] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ERISA Regulatory Cost] [float] NULL,
[Effective Date] [datetime] NULL,
[Exchange Rate - Buy Lot] [float] NULL,
[Exchange Rate Source] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Exchange Ticker] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Expanded Broker Reason Code] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FX Type] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Fees/Other (Base)] [float] NULL,
[Fees/Other (Local)] [float] NULL,
[First Payment Date] [datetime] NULL,
[Fiscal Year] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Foreign Indicator] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Free to Distribute Date] [datetime] NULL,
[Fund ID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Fund Name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Fund Type Code] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Fund of Funds Indicator] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Gain Loss Method Indicator] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ID Cost (Base)] [float] NULL,
[ID Cost (Local)] [float] NULL,
[ID Cost Base - Buy Lot] [float] NULL,
[ID Cost Local - Buy Lot] [float] NULL,
[ISIN Number] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[In Kind Flag] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[In Kind Trade Fees Flag] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[In Kind Transaction Code] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Income Currency Code] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Interest (Base)] [float] NULL,
[Interest (Local)] [float] NULL,
[Interest Rate] [float] NULL,
[Investment Type] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Investment Type Code] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Investor] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Issue Country Code] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LT Currency Gain/Loss] [float] NULL,
[LT Currency Gain/Loss - Buy Lot] [float] NULL,
[Last Closing Date] [datetime] NULL,
[Ledger Composite Fund] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Local 5 Year Gain/Loss Amount] [float] NULL,
[Local Amortization Sold] [float] NULL,
[Local Amortization Sold - Buy Lot] [float] NULL,
[Local Currency] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Local Currency Name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Local Fees] [float] NULL,
[Local Long Term Gain/Loss - Buy Lot] [float] NULL,
[Local Net Proceed Amount] [float] NULL,
[Local Net Settlement] [float] NULL,
[Local Original Average Cost] [float] NULL,
[Local Original Identified Cost] [float] NULL,
[Local Realized Gain] [float] NULL,
[Local Realized Gain/Loss] [float] NULL,
[Local Realized Loss] [float] NULL,
[Local Security Gain/Loss] [float] NULL,
[Local Short Term Gain/Loss - Buy Lot] [float] NULL,
[Long Short Indicator] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Long Term Gain/Loss (Base)] [float] NULL,
[Long Term Gain/Loss (Local)] [float] NULL,
[Lot Number] [float] NULL,
[Lot Number - Buy Lot] [float] NULL,
[Major Industry Code] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Major Industry Name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Manager Name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Maturity Date] [datetime] NULL,
[Minor Industry Code] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Minor Industry Name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Moody's Quality Rating] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NAV Day Date] [datetime] NULL,
[Net Amount (Base)] [float] NULL,
[Net Amount (Local)] [float] NULL,
[Net Gain/Loss (ID Cost - Base)] [float] NULL,
[Net Gain/Loss (ID Cost - Local)] [float] NULL,
[Net Trade Indicator] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Option Expiration Date] [datetime] NULL,
[Orig Trade Date] [datetime] NULL,
[Original Face] [float] NULL,
[Original Interest Rate] [float] NULL,
[Original Maturity Date] [datetime] NULL,
[Original Multiplier] [float] NULL,
[Original Trade Date - Buy Lot] [datetime] NULL,
[Original Trade ID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Original Transaction Type] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Payment Frequency Code] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Pool ID Number] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Pool Type Code] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Post Date] [datetime] NULL,
[Price (Base)] [float] NULL,
[Price (Local)] [float] NULL,
[Price Source] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Principal Trade Switch] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Realized Gain/Loss (Average Cost - Base)] [float] NULL,
[Realized Gain/Loss (Average Cost - Local)] [float] NULL,
[Report Date] [datetime] NULL,
[Restrict Lot Indicator] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[S and P Quality Rating] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[S3 Currency Gain/Loss] [float] NULL,
[SSC Trade ID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ST Currency Gain/Loss] [float] NULL,
[ST Currency Gain/Loss - Buy Lot] [float] NULL,
[Security Description] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Security Description 2] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Security Name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Security Name/Description] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Segregated Lot] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Sell Exchange Rate] [float] NULL,
[Settlement Comment] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Settlement Currency] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Settlement Date Exchange Rate] [float] NULL,
[Settlement Location] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Settlement Status] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Shares/Par] [float] NULL,
[Shares/Par - Buy Lot] [float] NULL,
[Short Sell Indicator] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Short Term Gain/Loss- Base] [float] NULL,
[Short Term Gain/Loss- Local] [float] NULL,
[Short3 Gain/Loss- Base] [float] NULL,
[Short3 Gain/Loss- Local] [float] NULL,
[State Code] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Swap Fund Number] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax Country Code] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Taxes (Base)] [float] NULL,
[Taxes (Local)] [float] NULL,
[Ticker] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Trade Country Code] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Trade Currency] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Trade Date] [datetime] NULL,
[Transaction Code] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Transaction Type] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Transaction Type Detail] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Update Date/Time] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'VirtualFolder', N'SSB Stuff', 'SCHEMA', N'dbo', 'TABLE', N'PSFull', NULL, NULL
GO
